Read about current recordset not support updating, The latest news, videos, and discussion topics about current recordset not support updating from alibabacloud.com
A summary of the Recordset object
A Recordset object represents the complete collection of records from the results of a basic table or command execution. In any case, the current record that the object refers to is a single record within the
Rs.Open sql,conn,a,b
A:
adOpenForwardOnly (=0)
Read-only, and the current data record can only move down.
adOpenKeyset (=1)
Read-only and the current data record is free to move.
adOpenDynamic (=2)
Can read and write, the current data record can be
ADO today for some of the methods of the Recordset object.
1, AddNew method
Creates a new record that can update the Recordset object.
Recordset. AddNew FieldList, Values
FieldList Optional. A single name, group name, or ordinal position of a field
ADO today about the properties of the Recordset object
1, CursorType Property
adOpenForwardOnly: Forward-only cursors, default values. In addition to scrolling forward only in records, it is the same as a static cursor. Use it to improve performance
In the last lecture, we learned how to connect to a database and retrieve data from a database, and today's content is how to add new data to the database, modify and delete the data in the database.First, add new data to the databaseMethod One: Use
ado| Program | programmer | Design SUMMARY: This article discusses how to implement basic database operations in a ado.net manner and when to use ado.net instead of ADO.
Directory
Data access in. NET
Reading data
Datasets, DataTable, and
ado| Program | programmer | Design SUMMARY: This article discusses how to implement basic database operations in a ado.net manner and when to use ado.net instead of ADO.
Directory
Data access in. NET
Reading data
Datasets, DataTable, and
ADO. NET will be used to build data awareness.. NET application. unlike ADO, ADO. NET is more universal, not so specific to the database design. ADO. NET aggregates all classes that can process data. these classes present data container objects with
[Preface]
When we use visual c ++ for ADO programming, processing the variant field type is a headache. The common practice is to first convert the variant type to a similar C ++ type, and then store the converted data in a class or structure. Even
Reference | Beginners Common acronyms and Chinese meanings
WWW----World Wide web (WWW)
URL----Uniform Resource Locator (Uniform Resource Locator)
HTTP----Hyper text Transfer Protocol (Hypertext Transfer Protocol)
HTML----Hyper text Markup Language (
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.